日志
常用的phpmyadmi SQL语句
热度 333 |
批量删除数据表里TAB列含有“GBK：的行
DELETE FROM `dede_taglist` WHERE `tag` LIKE '%gbk%' 批量删除数据表里小于2个字符的行
delete from `dede_taglist` where length(trim(`tag`)) < 3;
批量更新数据表content里的关键词
UPDATE `wiki_doc` SET `content` = REPLACE (`content`, 'old', 'new');
批量删除dede数据表里无效TAG
DELETE FROM `dede_tagindex` WHERE typeid not in (select id from dede_arctype); DELETE FROM `dede_taglist` WHERE typeid not in (select id from dede_arctype);
批量删除无效连接
update `wiki_doc` set `content` = replace (`content`, substring (`content`, locate("<a ", `content`), locate(">", `content`, locate("<a ", `content`))+1-locate("<a ", `content`)),"");
批量删除所有外链：
mentmetaeta_key='url';
批量删除指定域名的外链：
mentmetaetaeta_value LIKE '%域名%';
批量删除指定IP地址的外链：
mentmetaetaeta_value LIKE '%IP地址%';
